package com.alex.goods.service;

import com.alex.goods.entity.GoodsOrders;
import com.alex.goods.entity.InOutSum;

import java.util.List;

public interface OrdersService {
	

	List<GoodsOrders> selectOrdersList(String sql, Integer page, Integer limit);

	void addOrder(String goodsNo, String factory, String singlePrice, Integer num, String unit,
			String dateio,
			String personName,
			String tel, String status);
	
	Long getOrdersNum(String sql);

	Long getInOutNum(String sql);

	List<InOutSum> selectSumList(String sqlfrom, Integer page, Integer limit);

	List<InOutSum> selectSumByGoodsNo(String goodsNo,String start,String end,String status1,String Status2);

	void updateOrder(String goodsNo,String orderNo ,  String factory, String singlePrice,Integer num, String dateio, String unit,
			String personName, String tel, String statusx);

	void deleteOrderByOrderNo(String orderNo, String goodsNo);
   
}
